<?php

class IndexController extends Site_Controller_Action
{
    
    public function init()
    {
        /* Initialize action controller here */
    }

    public function indexAction()
    {
        $fullbanner = $this->db->fetchAll('SELECT SQL_CACHE * FROM FULLBANNER WHERE BAN_STA = 1 ORDER BY BAN_ORD ASC');
        $this->view->fullbanner = $fullbanner;  
        
        $query = 'SELECT SQL_CACHE * FROM AMBIENTES WHERE AMB_STA = 1 ORDER BY AMB_ORD ASC';
        $result = $this->db->fetchAll($query);
        $this->view->ambientes = $result;
    }
}

